SELECT
complaintTypeNm,
COUNT(*) AS number
FROM
BOMC_CUST
WHERE
task_create_time = DATE_SUB( CURDATE(), INTERVAL 1 DAY )
AND complaintType = "余额被停机"
GROUP BY
complaintTypeNm
ORDER BY
number DESC